using System;
using WP.Commons;

namespace WP.MF.DataAccess
{
	/// <summary>
	/// Summary description for MCountyDAL.
	/// </summary>
    public class MCountyDAL : IDataAccess
	{
		public MCountyDAL()
		{
			//
			// TODO: Add constructor logic here
			//
		}

        #region Select List
        public string SQLList(int iParameter)
        {
            string strSQL = @"select RecId,CountyNo,CountyDesc,ProvNo from mCounty order by CountyNo ";
            //string strSQL = @"select RecId,CountyNo,CountyDesc,ProvNo,TaxPCT,ShortDesc from mCounty order by CountyNo ";
            return strSQL;
        }
        #endregion

        #region Fields
        public string Fields
        {
            get
            {
                return @"CountyNo,CountyDesc,ProvNo,TaxPCT,ShortDesc";
            }
        }
        #endregion
	}
}
